Need a simple way to work out APS and percentages for 2c+, 2B and level 3 for a whole cohort, boys, girls, SEN, non-SEN, disadvantaged and non-disadvantaged? Just enter the details and results of each child and the spreadsheet will do the work for you! You can even add 2014 data for comparisons, taken from RAISE. Perfect for Governors, subject or Phase leader reports. Files also print out onto A4. Available for 30 or 60 children

This spreadsheet will analyse the progress made by your reception class for each area of learning. Simply follow the steps to achieve this: Add a '1' to show each child's attainment on entry and exit to reception for each of the 7 areas That's it! The spreadsheet will give you all the information you need for your SEF, school analysis and action plans. It will give you percentages of below typical, typical and above typical for each area and also give you a breakdown for terms of birthday, PPG status and Gender. All sheets are in colour for ease of reading and are designed to print out onto A4

Simply enter the scores for each child for each question, their gender, SEN and PPg status and the spreadsheet will give you: a breakdown of each question percentage the percentage overall, boys and girls for each area - number, calculation, geometry, statistics, measurement and fractions, decimals and percentage overall percentages for each of these areas for gender, PPG, non PPG, SEN and non SEN ideal for school and subject leaders as well as teacher analsysis of strengths and areas for development See the read me file for links to other year groups analysis spreadsheets

12 mats - 6 in colour, 6 b/w. All with clipart to reinforce the language. 15 words for each them. animals and plants in their environment variation sound and hearing using electricity sorting and using materials pushes and pulls see the read me file for links to 100s of science language resources, activities and games

12 mats - 6 in colour, 6 b/w. All with clipart to reinforce the language. 20 words for each them. more about dissolving reversible and irreversible interdependence and adaptation life cycles keeping healthy micro-organism see the read me file for links to 100s of science language resources, activities and games

Simply enter the scores for each child for each question, their gender, SEN and PPg status and the spreadsheet will give you: a breakdown of each question percentage the percentage overall, boys and girls for each area - number, calculation, geometry, statistics, measurement and fractions, decimals and percentage overall percentages for each of these areas for gender, PPG, non PPG, SEN and non SEN ideal for school and subject leaders as well as teacher analysis of strengths and areas for development See the read me file for links to other year groups analysis spreadsheets

simply enter the scores for each child for each question for the 2016 SPAG test, their gender, SEN and PPg status and the spreadsheet will give you: a breakdown of each question percentage the percentage overall, boys and girls for each area - meaning, retrieval, inference, prediction, content, words and phrases and comparison. overall percentages for each of these areas for gender, PPG, non PPG, SEN and non SEN ideal for school and subject leaders as well as teacher analsysis of strengths and areas for development Links to resources GaPS https://www.tes.com/teaching-resource/detailed-analysis-of-2016-sats-grammar-punctuation-and-spelling-test-11313084 Maths https://www.tes.com/teaching-resource/detailed-question-level-breakdown-and-analysis-of-maths-2016-sats-test-11314237 Reading https://www.tes.com/teaching-resource/detailed-question-level-breakdown-and-analysis-of-2016-sats-reading-test-11314959 All 3 spreadshseets https://www.tes.com/teaching-resource/detailed-question-level-breaskdown-and-analysis-of-2016-sats-gaps-reading-and-maths-test-11314970

simply enter the scores for each child for each question for the 2016 SPAG test, their gender, SEN and PPg status and the spreadsheet will give you: a breakdown of each question percentage the percentage overall, boys and girls for each area - grammar, sentence strructure, phrases, verb forms, punctuation, vocabulary and standard English overall percentages for each of these areas for gender, PPG, non PPG, SEN and non SEN ideal for school and subject leaders as well as teacher analsysis of strengths and areas for development Links to resources GaPS https://www.tes.com/teaching-resource/detailed-analysis-of-2016-sats-grammar-punctuation-and-spelling-test-11313084 Maths https://www.tes.com/teaching-resource/detailed-question-level-breakdown-and-analysis-of-maths-2016-sats-test-11314237 Reading https://www.tes.com/teaching-resource/detailed-question-level-breakdown-and-analysis-of-2016-sats-reading-test-11314959 All 3 spreadshseets https://www.tes.com/teaching-resource/detailed-question-level-breaskdown-and-analysis-of-2016-sats-gaps-reading-and-maths-test-11314970

Enter each pupil’s details - name, gender, PPG and SEN status as well as their KS1 and KS2 SATs outcomes and this spreadsheet automatically calculates: The prior attainment group (PAG) group for each child individual, class and group pupil progress and attainment calculates children’s attainment and progress based on their cohort, gender, PPG and SEN status See pictures for how the data is shown. what to do: enter each child’s name, gender, PPG and SEn status to the pupil info tab only Enter KS1 results (includes P levels) Enter KS2 results scaled scores for maths and reading. For writing the following codes are accepted - GD, EXS, WTS, PKG, PKE, PKF, BLW, P8, P7, P6, P5, P4, P3ii, P3i, P2ii, P2i ,P1ii, P1i From here the spreadsheet does the rest Calculates the PAG for each child and from this, sets the targets in reading, writing and maths for each child, based on a R&W average and then a KS1 average - see attached DfE document for further guidance Once the KS2 data is added, the spreadsheet calculates each child’s progress and this is reflected in a green or red formatting for easy reference On the summary tab, progress scores are calculated for the whole cohort, boys, girls, disadvantaged and other, SEN support and no SEN. The percentage achieving the standard or higher for each of these groups as well as the percentages achieving RWM for each category. This is mirrored for the percentage of children achieving the higher standard in for each group and RWM. Finally, the average scaled scores are calculated for overall and each group. In addition, you can enter your 2017 data for easy comparison. Each sheet fits neatly onto an A4 sheet for use by governors, SLT or school ‘visitors’ UPDATE** if you purchased an earlier version please see the alterations below My apologies – I sent out an earlier version of the spreadsheets to you. It affects the boy/girl, disadvantaged and SEN progress for reading and maths only. It is easy to fix On the summary tab, click in cell D7. The formula reads =IFERROR(((SUMIF(‘Pupil Info’!B:B,“male”,‘Ind Pupi Progress’!C:C))/COUNTIFS(‘Pupil Info’!B:B,“male”,‘Ind Pupi Progress’!C:C,">10")-100),"") where it is C:C this should be D:D and the -100 needs deleting (keep the brackets though) This needs repeating for cells D8-D12 In maths, it is similar =IFERROR(((SUMIF(‘Pupil Info’!B:B,“male”,‘Ind Pupi Progress’!I:I))/COUNTIFS(‘Pupil Info’!B:B,“male”,‘Ind Pupi Progress’!I:I,">10")-100),"") The I:I needs altering to J:J and delete the -100 again for cells F7 to F12

simply enter the scores for each child for each question for the 2016 SPAG test, their gender, SEN and PPG status and the spreadsheet will give you: a breakdown of each question percentage the percentage overall, boys and girls for each area - number, place value, calculation, geometry, ratio, fractions, decimals, percentages, measurement, statistics and algebra overall percentages for each of these areas for gender, PPG, non PPG, SEN and non SEN ideal for school and subject leaders as well as teacher analsysis of strengths and areas for development Links to resources GaPS https://www.tes.com/teaching-resource/detailed-analysis-of-2016-sats-grammar-punctuation-and-spelling-test-11313084 Maths https://www.tes.com/teaching-resource/detailed-question-level-breakdown-and-analysis-of-maths-2016-sats-test-11314237 Reading https://www.tes.com/teaching-resource/detailed-question-level-breakdown-and-analysis-of-2016-sats-reading-test-11314959 All 3 spreadsheets https://www.tes.com/teaching-resource/detailed-question-level-breaskdown-and-analysis-of-2016-sats-gaps-reading-and-maths-test-11314970

Simply enter the scores for each child for each question, their gender, SEN and PPg status and the spreadsheet will give you: a breakdown of each question percentage the percentage overall, boys and girls for each area - number, calculation, geometry, statistics, measurement and fractions, decimals and percentage overall percentages for each of these areas for gender, PPG, non PPG, SEN and non SEN ideal for school and subject leaders as well as teacher analsysis of strengths and areas for development

Need a clear, consistent and easy to use system for assessing Year 4 Maths without levels? Year 4 maths areas covered: number and place value fractions statistics geometry addition subtraction multiplication division measurement The series contain over 200 short assessment tasks for every statement from year 1 to year 6. Assessment without levels is about continuous assessment but within a structured and robust system to ensure consistency of approach. These assessments can be done quickly, at any time and repeated as the children will not know the answers. They can be done as a class, a group or individually. The number of assessments are as follows Year 1 – 20 Year 2 – 34 Year 3 - 33 Year 4 – 44 Year 5 - 49 To support teachers, I have provided: • Answers for each sheet • Colour coded year group sheets • An overview of all the statements organised by mathematical area • A guide on what stage to assess the children at. I have used beginning, working within and secure as statements but these can be adapted to your system This is the first part of a major scheme - maths squared - that will encompass pre-learning, focus on maths vocabulary. activities and assessment. So please do follow me to keep up to date

Need a clear, consistent and easy to use system for assessing Year 2 Maths without levels? Year 2 maths areas covered: number and place value fractions statistics geometry addition subtraction multiplication division measurement The series contain 233 short assessment tasks for every statement from year 1 to year 5. Assessment without levels is about continuous assessment but within a structured and robust system to ensure consistency of approach. These assessments can be done quickly, at any time and repeated as the children will not know the answers. They can be done as a class, a group or individually. The number of assessments are as follows Year 1 – 20 Year 2 – 34 Year 3 - 33 Year 4 – 44 Year 5 - 49 Year 6 - 53 To support teachers, I have provided: • Answers for each sheet • Colour coded year group sheets • An overview of all the statements organised by mathematical area • A guide on what stage to assess the children at. I have used beginning, working within and secure as statements but these can be adapted to your system

Need a clear, consistent and easy to use system for assessing Year 1 Maths without levels? Year 1 maths areas covered: number and place value fractions geometry addition subtraction multiplication division measurement The series contain 233 short assessment tasks for every statement from year 1 to year 5. Assessment without levels is about continuous assessment but within a structured and robust system to ensure consistency of approach. These assessments can be done quickly, at any time and repeated as the children will not know the answers. They can be done as a class, a group or individually. The number of assessments are as follows Year 1 – 20 Year 2 – 34 Year 3 - 33 Year 4 – 44 Year 5 - 49 Year 6 - 53 To support teachers, I have provided: • Answers for each sheet • Colour coded year group sheets • An overview of all the statements organised by mathematical area • A guide on what stage to assess the children at. I have used beginning, working within and secure as statements but these can be adapted to your system

Need a clear, consistent and easy to use system for assessing Year 3 Maths without levels? Year 3 maths areas covered: number and place value fractions statistics geometry addition subtraction multiplication division measurement The series contain 233 short assessment tasks for every statement from year 1 to year 5. Assessment without levels is about continuous assessment but within a structured and robust system to ensure consistency of approach. These assessments can be done quickly, at any time and repeated as the children will not know the answers. They can be done as a class, a group or individually. The number of assessments are as follows Year 1 – 20 Year 2 – 34 Year 3 - 33 Year 4 – 44 Year 5 - 49 Year 6 - 53 To support teachers, I have provided: • Answers for each sheet • Colour coded year group sheets • An overview of all the statements organised by mathematical area • A guide on what stage to assess the children at. I have used beginning, working within and secure as statements but these can be adapted to your system

Need a clear, consistent and easy to use system for assessing Year 5 Maths without levels? Year 5 maths areas covered: number and place value fractions statistics geometry addition subtraction multiplication division measurement The series contain 233 short assessment tasks for every statement from year 1 to year 5. Assessment without levels is about continuous assessment but within a structured and robust system to ensure consistency of approach. These assessments can be done quickly, at any time and repeated as the children will not know the answers. They can be done as a class, a group or individually. The number of assessments are as follows Year 1 – 20 Year 2 – 34 Year 3 - 33 Year 4 – 44 Year 5 - 49 Year 6 - 53 To support teachers, I have provided: • Answers for each sheet • Colour coded year group sheets • An overview of all the statements organised by mathematical area • A guide on what stage to assess the children at. I have used beginning, working within and secure as statements but these can be adapted to your system

Simply enter the scores for each child for each question for the 2016 SPAG test, their gender, SEN and PPg status and the spreadsheet will give you: a breakdown of each question percentage the percentage overall, boys and girls for each area and overall percentages for each of these areas for gender, PPG, non PPG, SEN and non SEN in GAPS - grammar, sentence strructure, phrases, verb forms, punctuation, vocabulary and standard English Maths - number, place value, calculation, geometry, ratio, fractions, decimals, percentages, measurement, statistics and algebra Reading - meaning, retrieval, inference, prediction, content, words and phrases and comparison. ideal for school and subject leaders as well as teacher analsysis of strengths and areas for development Links to resources GaPS https://www.tes.com/teaching-resource/detailed-analysis-of-2016-sats-grammar-punctuation-and-spelling-test-11313084 Maths https://www.tes.com/teaching-resource/detailed-question-level-breakdown-and-analysis-of-maths-2016-sats-test-11314237 Reading https://www.tes.com/teaching-resource/detailed-question-level-breakdown-and-analysis-of-2016-sats-reading-test-11314959 All 3 spreadsheets https://www.tes.com/teaching-resource/detailed-question-level-breaskdown-and-analysis-of-2016-sats-gaps-reading-and-maths-test-11314970

spreadsheets for the SPAG, reading and maths 2014 year 6 SATs. Simply enter the marks for each question and the spreadsheets with analyse strengths and areas for development for each area of learning. Based on my 5-star rated analysis sheets from 2014